
/*
*Pool Public Licence version 0.1 or later
*Released on 20th April 2008.
*Any voilations can be repoted at paritosh@wikiocean.net
*What is treated as voilations can be found at www.wikiocean.net/ppl1-voilations* 
******************************************************************************
* The contents of this file are subject Affero GPL v3 and later with additional conditions.
* The additional conditions are to be considered as part of the Affero GPL v3 and later.
* The additional conditions will supersede the Affero GPLv3 and later in case of conflict.
* ("License"); You may not use this file except in compliance with the License
* You may obtain a copy of the License at http://www.gnu.org/licenses/agpl.html
* Software distributed under the License is distributed on an "AS IS" basis,
* WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for
* the specific language governing rights and limitations under the License.
* The Initial Developer of the Original Code is Paritosh Pungaliya.
* created by Paritosh Pungaliya are Copyright (C) Paritosh Pungaliya; All Rights Reserved.
* Contributions are Copyright (C) 2001-2008 Paritosh Pungaliya.

* Objective of the additional terms (license) 
* 1) Is to extend the software freedom to freedom to work.
* 2) To ensure that knowledge is free from monopoly of agencie(s).
* 3) To avoid a situation where big corporates or investors can buy out free software groups and companies and then start milking the communities built around it.
* (this trend can be seen how the openness changes in companies that get Venture Capital funding.)
* (if you agree to this logic I invite you to our group to work together)

* Additional conditions
*  0) Source code will also include
* 	a) data dictionaries, data ontologies which are used to alter the behavior of code or to control           the features of application.
* 	b) Any code generated or derived automatically or manually from this code or logic
*  1) The revenue generated by deploying, implementing , selling services and other activities
*  	 based on this source code should be shared 100%, between the people working on it.
*  2) Capital invested should be given only fixed rate of return or linked to revenue/surplus growth for limited time.
*  3) People working on the project should always have an option to replace the capital provider in full or part with lower cost capital.
*  4) Their should not be any ownership which can be sold as a claim on future profit to be generated from the work of people working on the code.
*  5) Brand thus generated should belong to the group.
*  6) For old and new members revenue sharing should be equal for same work equivalent.
*  7) The share of revenue should be decided by bidding for work before allocation of work within the group.
*  8) Before bidding various method of measuring the work should be clearly defined and published in public domain. Any change in process should also be publised in public domain imediately.
*  9) All data related to to revenue sharing should be published as and when generated in public domain.
*  10) For group of people having size more than 10 people will have to make it open online for others to participate in bids. 
*  11) All people involved in related and sub project will be treated as a group.
*  12) Once this license is being used for a certain code then all and any other software services being provided by the group should complusorilly come under 100% revenue sharing.
*  13) Cross subsidization should not happen under this revenue share, no additional benefit should be drawn from the people, by the employing agency.
*  14) Any position or knowledge or legal structure created relating to people working on code, which adversely affects the spirit of 100% revenue share will be treated as a violation.
*  15) Revenue sharing defined.
*     a) includes direct revenue and also intangible gains like brand, and organization.
*     b) No personal judgment should be involved in judging the distribution of revenue.It has to be pre-defined formula based.
*     c)100% of revenue should be shared before expenses and recievers should have control over what expenses to incur.
*     d)For the work done in any month by contributing group member, working on any project can be given revenue share from the work done by the group, for a maximum of 18 months after that month.
*     e)Revenue should be apportioned to the month in which work is done and not when received.
*  The group fulfilling the above conditions also has to be a wiki ecosystem further defined in www.wekosystem.org or read about Wekosystem at www.wikiocean.net

*  ******************************************************************************
*/  
package logger;

// ProcessLogger Contains --> Msg_id Parent_id Request Process	Source(table Name)	Data	DateTime	Status

import java.io.*;
import java.util.*;
import java.text.SimpleDateFormat;

import timer.ExecutionTimer;
import timer.TimerRecordFile;
import utility.*;
import database.RecordSearch;
import dbmanager.*;
import file.FileOperation;
import file.FileUtility;


public class ProcessLogger
{	
	
	DBManager database;
	FileUtility fu;
	GetIdName getIdName;
	
	final String MSG_ID = "msgid";	
	final String REQUEST = "request";
	final String PROCESS = "process";	
	final String DATE = "date";
	final String STATUS = "status";
	final String SCHEDULEDATE="scheduledate";
	final String DATA = "data";
	final String MASTEROBJECT = "masterobject";
	final String USERNAME = "username";
	final String TYPE="mastertype";
	final String PRODUCT="product";	
	final String tablename= "eventprocess";
	
	GetIdName gin;
	
	Hashtable<Object, Object> inithash = new Hashtable<Object, Object>();
		
	MyDate date;
		
	Date now = Calendar.getInstance().getTime();
	SimpleDateFormat formatter = new SimpleDateFormat("dd-MM-yyyy");
	String currentDate=formatter.format(now.getTime()).toString();
    
	

	String LogDir = Input.PROCESSLOGGERPATH;	
	Date datetime;
	FileWriter fwrite;
	String loggerpath;
	
	String arr1Clmn[];
	String Msg_id;	
	public ProcessLogger(DBManager sqlDB)
	{
		ExecutionTimer t = new ExecutionTimer();
		 t.start();
		inithash.put(MSG_ID, MSG_ID);    	
    	inithash.put(REQUEST, REQUEST);
    	inithash.put(PROCESS, PROCESS);
    	inithash.put(REQUEST, REQUEST);
    	inithash.put(DATE, DATE);
    	inithash.put(STATUS, STATUS);
    	inithash.put(DATA, DATA);
    	inithash.put(USERNAME, USERNAME);    	
    	
    	
    	database = sqlDB;
    	gin = new GetIdName(database);
    	
    	File temp = new File(LogDir);
    	if(temp.exists()==false)
    		temp.mkdirs();
    	t.end();
		TimerRecordFile timerFile=new TimerRecordFile("logger","ProcessLogger","ProcessLogger",t.duration());
    }

	
	public void addLog(String Msg_id, String Request, String Process, String Data, String Username,String Product,String Type)
	{	
		 ExecutionTimer t = new ExecutionTimer();
		 t.start();
		try
		{
			formatter = new SimpleDateFormat("dd-MM-yyyy dd:mm:ss");
			String currentDateTime = formatter.format(now.getTime()).toString();			
			
	    	
	    	System.out.println (inithash);
	    	
			//database.getInsert(tablename, inithash);
			// adding events to process logger
			try
			{
				Hashtable<Object,Object> event = new Hashtable<Object,Object>();
				event.put(MSG_ID, Msg_id);
					// coming from msg_id of previous request in cascade process
				
				event.put(PROCESS, Process);
			//	event.put(DATE, currentDateTime);		
				event.put(REQUEST,Request);		// get this field from meta data of database i.e. name of the table
				event.put(STATUS,"0");
		    	event.put(DATA, Data);
		    	event.put(USERNAME, Username);
		    	event.put(PRODUCT, Product);
		    	event.put(TYPE, Type);
		    	
		    	//database.getInsert(tablename, event);
				Hashtable<Object,Object> condition = new Hashtable<Object,Object>();	        		
			       
				getIdName = new GetIdName(database);
			//	String getIdOfRequest = getIdName.getId(Request);
				String getIdOfEvent = getIdName.getId("Event");
							
				int pv_index = Column.pv_index-1;
				int vt_index = Column.vt_index-1;
				int ref_index = Column.ref_index-1;
				
				condition.put("pid", getIdOfEvent);
				condition.put("mid", Type);
				
				RecordSearch ps = new RecordSearch(database);
				ps.setConditionMap(condition);
				String temp[] = ps.getArrayFromResultSet();
				temp = sortArrayIndex(temp, ref_index); 
					
				for (int i=0; i<temp.length; i++)
				{
					String record[] = temp[i].split("\t");
					String value="";
					if (record[pv_index].equals("0")== true)
						value = record[vt_index];
					else
						value = (record[pv_index]);
					event.put(MASTEROBJECT, value);
					event = ConvertToLower.convertHashKey(event);
					database.getInsert(tablename, event);
				}
			}
			catch(Exception e){
				e.printStackTrace();
			}
		}
		catch(Exception e)
		{
			File dir = new File(LogDir);
			dir.mkdir();
			System.out.println("logger::ProcessLogger:: addLog()::error ");
			e.printStackTrace();
		}
		t.end();
		 TimerRecordFile timerFile=new TimerRecordFile("logger","ProcessLogger","addLog",t.duration());
	}
	
	@SuppressWarnings("unchecked")
	public void updateLog (String Msg_id, String Parent_id, String Request, String Status)
	{
		 ExecutionTimer t = new ExecutionTimer();
		 t.start();
		formatter = new SimpleDateFormat("dd-MM-yyyy DD:MM:SS");
		String currentDateTime = formatter.format(now.getTime()).toString();
		Hashtable<Object, Object> htip = new Hashtable<Object, Object>();	

		try
		{	
			htip.put(MSG_ID, Msg_id);	    	
	    	htip.put(REQUEST, Request);	    		    		    	
	    	loggerpath = LogDir+currentDate+Input.FILRFORMAT;
			
	    	inithash.put(STATUS, Status);
			inithash.put(DATE, currentDateTime);
			
			database.getUpdate(tablename,inithash,htip);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		t.end();
		 TimerRecordFile timerFile=new TimerRecordFile("logger","ProcessLogger","updateLog",t.duration());
	}
	
	public String[] sortArrayIndex(String[] recordSet,int indexOfField) 
	{
		 ExecutionTimer t = new ExecutionTimer();
		 t.start();
		int min = 0;
		
		for(int j=0;j<recordSet.length;j++)
		{
			int indexOfSort = 0;
			
			String []Values = recordSet[j].split("\t");
			try
			{
				indexOfSort = Integer.parseInt(gin.getItem(Values[indexOfField]));
			}
			catch (Exception e)
			{
				indexOfSort=0;
			}
			
			min = indexOfSort;
			int Precedence = 0;
			for(int i=j+1;i<recordSet.length;i++)
			{
				String splitrecordSet[]=recordSet[i].split("\t");
				try
				{
					Precedence = Integer.parseInt(gin.getItem(splitrecordSet[indexOfField]));
				} catch (Exception e) 
				{
					Precedence =0;
				}
				if(min > Precedence)
				{
					String temp = recordSet[j];
					recordSet[j] = recordSet[i];
					recordSet[i] = temp;
					min = Precedence;
				}
			}
		}
		t.end();
		 TimerRecordFile timerFile=new TimerRecordFile("logger","ProcessLogger","sortArrayIndex",t.duration());
		return recordSet;
	}
	
	public void deleteLogRecord (String Msg_id, String Parent_id, String Request, String Status)
	{
		 ExecutionTimer t = new ExecutionTimer();
		 t.start();
		Hashtable<Object, Object> htip = new Hashtable<Object, Object>();	
		try
		{	
			this.Msg_id = Msg_id;
			htip.put(MSG_ID, Msg_id);	    	
	    	htip.put(REQUEST, Request);
	    	htip.put(STATUS, Status);
	    		    		    	
	    	File dir = new File(LogDir);
			if(dir.exists())
				dir.mkdir();
						
			loggerpath = LogDir+currentDate+Input.FILRFORMAT;
			
			file.FileWriter filewriter = new file.FileWriter(loggerpath,"rws");
			FileOperation fo = new FileOperation(filewriter.fileOpen());
			fo.deleteFileRecord(htip);
			filewriter.fileClose();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		t.end();
		 TimerRecordFile timerFile=new TimerRecordFile("logger","ProcessLogger","deleteLogRecord",t.duration());
	}
		
	public static void main (String args[])
	{
		DBManager database =new DBManager();
		database.getConnect();
		ProcessLogger processLogger = new ProcessLogger(database);
		//processLogger.updateLog("0", "6", "serv", "5");
		//processLogger.deleteLogRecord("0", "6", "serv", "2");
		processLogger.addLog("1",  "add", "master", "ok done","+911234567891","pool","person");
		
	}
}